home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Night Owl 9
/
Night Owl CD-ROM (NOPV9) (Night Owl Publisher) (1993).ISO
/
010a
/
super25n.zip
/
SUPER30.DOC
< prev
next >
Wrap
Text File
|
1993-01-05
|
24KB
|
462 lines
Functional Software is proud to announce:
SuperLib 3.0
------------
100% 5.01 optimized source code
Over 300 functions with over 150 NEW functions
Downward compatible with prior SuperLibs
Extensive use of code blocks, Tbrowse and other new 5.01 features
No Publics, no privates
Norton Guide datafile
350+ page manual
Example code
Hungarian notation for easier memvar identification and modification
Multiuser (network) ready
Optimized, upgraded versions of Report Writer, Query, Form Letters,
Browse, Append, Edit and all previous SuperLib functions
Upgraded Labels - now with Avery Laserjet label Support
Improved text file reader, now with search and mark/copy/print
New Export (Delim & SDF)
New Mailmerge
New Tbrowse - delimited, sdf, array, multi-dim array
New Weights & Measures conversion metafunction
New Dbf stats metafunction
New Appointment book metafunction
New GET system enhancements including specialized get readers and
valid and when functions, Scrollable virtual get reader,
mouseable gets
New Restore screen enhancement functions including fade, shift off,
drop off, implode off - 15 in all
New Progress bar functions, including index, count, and generic bars
New Laserjet functions including box drawing
New Mouse and event functions including mouse-aware inkey() replacement
MANY New Popups and lookups, including asciitable, colorgrid,
memo selector/viewer, tag array, popup seek, achoice replacement...
New Menu types including 1-2-3, tabular, mouseable menu to
Plus many array, string, file, field, expression, conversion......
SuperLib 3.0 (5.01 optimized)
Function Listing by Category
-----------------------------
Array
-----
A2TOSING() Copies a given element from an array of arrays
AASKIP() Use for skipblock for arrays in Tbrowse
AAVERAGE() Average of an array with optional conditional set
AEXTRACT() Extract and return a conditional set from an array
AFDECIX() Returns an array of field DECIMALS for current dbf
AFIELDSTYPE() Returns an array of field names of particular type
AFIELDSX() Returns an array of field names for current dbf
AFLENSX() Returns an array of field LENGTHS for current dbf
AFTYPESX() Returns an array of field types for current dbf
AKOUNT() Counts exact matches of value in array
ALENG() Actual length of an array, less trailing nil elements
AMATCHES() Counts matches of an array with optional conditional set
AMAVERAGE() Average on a given element of multi-dim array
AMSTDDEV() Standard Deviation on a given element of multi-dim array
AMSUM() Sum on a given element of multi-dim array
AMVARIANCE() Variance on a given element of multi-dim array
ARRAY2DBF() Replaces the current record with the values in an array
ASORTMULT() Sort multiple arrays based on sort of primary array
ASORTMULTR() Reverse Sort multiple arrays based on sort of primary array
ASTDDEV() Standard deviation of an array with optional conditional set
ASUM() Sum of an array with optional conditional set
AUPDATED() Does array contain updated values for current record
AVARIANCE() Variance of an array with optional conditional set
BIGELEM() Returns length of longest string in an array
BLDARR() Builds an array from a delimited string
DBF2ARRAY() Returns an array of values for the current record
DELARRAY() Deletes all elements of an array
FILLARR() Fill type, length, decimal arrays
Conversion
----------
AT2CHAR() Returns the String color equivalent of a color attribute
NBR2STR() Correctly orders numerics where negative
NOZDIV() Prevents divide-by-zero
TRUEVAL() Returns val of ALL numerics in a string
DBF
---
BLDDBF() Create a DBF from a delimited string or an array
OPENIND() Opens an array of indexes
PICKNDX() Allows user to select indexes to open
PURGEM() Deletes records
QFLDSTYPE() Count # of fields of a given type or types
Date
----
BEGEND() Determines beginning or end of week,month, or quarter
BOM() Calculates beginning of the month date
BOYEAR() Determine beginning of year a date falls in
DATECALC() Adds/subtracts days,weeks,months,years to a date
DAYSIN() Calculates number of days in a month
DOYEAR() Calculates day of the year from date
DTDIFF() Returns difference between dates
DTOW() Converts date to words
SET_DATE() Sets and restores date format
SETCENT() Determines if century is on/off
STOD() Returns date from string in the form YYYYMMDD
WOMONTH() Calculates week of the month (# of 7 day periods)
WOYEAR() Calculates week of the year (# of 7 day periods)
Development
-----------
HELPMOD() Interactively build and modify help screens
SCMOD() Maintains scroller.dbf - see scroller()
SFRR_HCODE() Output report definition to .PRG code
Environment
-----------
GETDFP() Gets SET DEFAULT path
ISLOADED() Determines if function is loaded or not
PRNPORT() Determine Printer Port to use
RESTSETKEYS() Restores set keys saved with SAVESETKEYS()
SAVESETKEYS() Saves all active set keys to array, optionally clearing them
SETEXACT() Determines if exact is on/off
Event
-----
RAT_ELBHD() Determines if left mouse button is held down
RAT_EQMCOL() Returns mouse column at last press
RAT_EQMROW() Returns mouse row at last press
RAT_ERBHD() Determines if right mouse button is held down
RAT_EVENT() Event handler - inkey() with mouse awareness
RAT_ISMOUSE() Determines mouse usage by RAT_EVENT()
Expression
----------
BLANKFIELD() Returns a blank value corresponding to a field
BLANKREC() Blanks out a record
EXPBLOCK() Returns a codeblock to evaluate an expression
FIELDLENX() Returns length of field
FIELDPOSX() Returns decimals of field
FIELDTYPEX() Returns type of field
ISBLANKREC() Determines if a record is blank
ISFIELD() Determines if an expression is the name of a field
ISTHISAREA() Determines if expression is the name of a field in this area
PARSALIAS() Extracts the name of the alias from an expression
PARSFIELD() Extracts the name of the field from an expression
WORKBLOCK() Returns a set-get block for field named in an expression
File
----
FILEINFO() Returns file date,time,size
FMOVE2NEXT() Moves to beginning of next line in a text file
FMOVE2PRIOR() Moves to beginning of prior line in a text file
ISVALFILE() Checks a file name for validity
NKEY() Gets key of an index file
SFREADLINE() Reads in text up to the next CRLF in a text file
STRIP_PATH() Strip path and optionally extension from a filespec
WRITEFILE() Writes a line or lines to a text file
Get system
----------
CALCKCLR() Clears hot keys set by CALCKSET()
CALCKSET() Allows use of GETCALC() calculator in GETS
CALCVALID() Uses GETCALC() function as a GET VALID clause
CALCWHEN() Uses GETCALC() as a GET WHEN clause
CALENDKCLR() Clears hot keys set up by CALENDKSET()
CALENDKSET() Allows use of GETDATE() calendar in GETS
CALENDVALID() Uses GETDATE() as a GET VALID clause
CALENDWHEN() Uses GETDATE() function as a GET WHEN clause
ED_G_PIC() Returns appropriate picture for getting a field
GENREADER() Creates specialized user defined get reader block
GENVAL() Generic VALID clause validation with message
GETAKEY() Gets intent of last keystroke
PICKREADER() Creates specialized picklist reader block
PMREADER() Creates specialized PLUS/MINUS get reader block
POPUPKCLR() Clears GET hotkey popups set up with POPUPKSET()
POPUPKSET() Set a popup for hotkey access from a GET
POPUPVALID() Allows use of a popup for a GET VALID clause
POPUPWHEN() Allows use of a popup for a GET WHEN clause
RAT_READ() Mouseable read
SBREADER() Creates specialized spacebar spinner get reader block
SMALLKCLR() Clears GET-HOTKEY lookups set up with SMALLKSET()
SMALLKSET() Sets up GET-HOTKEY lookups using SMALLS()
SMALLVALID() Uses SMALLS() in a VALID condition for a GET
SMALLWHEN() Uses SMALLS() in a WHEN condition for a GET
YNREADER() Creates specialized Yes/No get reader block
Help
----
HELP() Provides context sensitive popup help
Hp Laserjet
-----------
SL_BOLD() Sets font stroke weight to BOLD (ultra black)
SL_BOX() Draws a box line from row,col to endrow,endcol
SL_COPIES() Sets the laserjet to print n copies of each page
SL_DOWNROW() Move the printer cursor up/down by # rows, relative
SL_EJECT() Ejects the current page
SL_FILL() Fills a rectangle with shading or a pattern.
SL_GOTO() Move the printer cursor to row/col
SL_HLINE() Draws a horizontal line from row,col to row,endcol
SL_ITALIC() Sets font style to italic
SL_ITALICOFF() Sets font style to upright (non italic)
SL_LANDS() Sets laserjet orientation to LANDSCAPE
SL_LEFTMARG() Sets the left margin to the left edge of the specified column
SL_NORMAL() Sets font stroke weight to NORMAL (non bold)
SL_OVERCOL() Move printer cursor right/left # columns relative
SL_PAGESIZE() Sets the page size on the laserjet
SL_POPCURS() Pops the printer cursor position for later popping
SL_PORT() Sets the laserjet orientation to PORTRAIT
SL_PUSHCURS() Pushes the printer cursor position for later popping
SL_RESET() Resets the printer to user defaults
SL_RIGHTMARG() Sets the right margin to right edge of the specified column
SL_SETCPI() Sets characters per inch
SL_SETLPI() Sets the lines per inch for the laserjet
SL_TOPMARG() Designates the number of lines of top margin
SL_UNDER() Sets automatic text underlining on
SL_UNDEROFF() Sets automatic text underlining off
SL_VLINE() Draws a vertical line from row,col to endrow,col
SL_WRAP() Sets line wrapping on or off
Keyboard
--------
CTRLW() Sends chr(23) (Control-W) to the keyboard
KBDESC() Keyboards character 27 (escape) when key pressed
SHIFTY() Determines shift key settings
Lookup
------
ISINLOOK() Checks for existence of a value in a lookup dbf
ISNOTDUP() Checks for a duplicate field
SCROLLER() Hotkey lookup tables with dbf storage
SMALLS() Lookup tables with optional KEYBOARD or code block
Menu
----
MENU_V() Vertical popup menu from variable # parameters
PSTABMENU() Popup tabular (grid style) menu
PULLDN() Pulldown menu creator, handler
RAT_MENU2() Mouseable MENU TO emulation
SLOTUSMENU() 1-2-3 style menu
STABMENU() Tabular (grid style) menu
Metafunction
------------
APPENDIT() Intelligent APPEND FROM replacement
BLDNDX() Interactively create a new index
BROWSEDELIM() Tbrowse a delimited file
BROWSESDF() Tbrowse an SDF file
BUILDEX() Interactively builds and returns an expression string
CLABEL() Menu driven module for label management
COPYFIELDS() Copies selected fields of selected records to new dbf
COPYITOUT() Copies records to a new DBF
DBSTATS() Statistical report on current dbf
DUPHANDLE() Duplicate record finder with delete/copy options
DUPLOOK() Locates possible duplicates based on user criteria
EDITDB() Customized browser with edit/add/search capabilities
FASTFORM() Prints a selected formletter for current record
FILEREAD() Lists a text file of unlimited size
FORMLETR() Interactive formletter and mailmerge utility
FREQANAL() Performs a frequency analysis on a DBF
FULLDIR() Interactively navigate directories
GENED() Generic dbf editing screen
GLOBREP() Performs global selective replace of a field
LISTER() Build, format,print lists to printer,screen,file
MODIFY() Create or modify DBF structures
QUERY() Popup Interactive query by example condition builder
REPORTER() Create, modify, execute reports
SAPPOINT() Appointments manager - uses popup calendar.
SCONVDELIM() Convert a delimited file to a DBF
SEARCHME() Search a DBF with user-specified criteria
SEXPORT() Export DBF to delimited or SDF files
SMAILMERGE() Creates mailmerge files for WordPerfect & MS Word
SUM_AVE() Interactive sum or average on a dbf field
SUPERSUPER() Datafile management proc - uses most Metafunctions
TAGIT() Tag records in a dbf for later action
TIMEPER() Time Period (date sensitive) DBF analysis
TODOLIST() Simple todo list manager
VIEWPORT() Multi-optional data entry engine
WGT_MEAS() A Weights and Measures conversion metafunction
Misc/Other
----------
CDIR() Change Directory
CURD() Return current drive letter
ENDSWITH() Determines if a string ends with another string
EVALQ() Evaluates a logical condition in a string
ISPART() Determines if a value is part of a set
ISPRN() Detects printer ready (or not) on LPT1, 2 or 3
PRNTFRML() Prints a formletter created by formletr()
SBCENTER() Centers box coordinates
SBCOLS() Determine number of columns in a box
SBROWS() Determine number of rows in a box
VARLEN() Returns length of a variable of any type
Mouse
-----
RAT_AREA() Limits the mouse to a rectangular area of the screen
RAT_COL() Current mouse column
RAT_COLL() Returns mouse column at the last left button press
RAT_COLR() Returns mouse column at the last right button press
RAT_EXIST() Determines if a mouse is available
RAT_LBHD() Determines if the mouse left button is currently depressed
RAT_LEFTB() Determines if the left mouse button has been pressed
RAT_OFF() Sets the mouse cursor off
RAT_ON() Sets the mouse cursor on
RAT_POSIT() Positions the mouse cursor at row,column coordinates
RAT_RBHD() Determines if the mouse right button is currently depressed
RAT_RESET() Resets the mouse to its default values
RAT_RIGHTB() Determines if the right mouse button has been pressed
RAT_ROW() Current mouse row
RAT_ROWL() Returns mouse row at the last left button press
RAT_ROWR() Returns mouse row at the last right button press
NETWORK
-------
SADD_REC() Attempts to append a blank record
SFIL_LOCK() Attempts to lock a file
SNET_USE() Attempts to open a DBF
SREC_LOCK() Attempts to lock a record
UNIQFNAME() Creates a unique file name
Popup
-----
ABORT() Pops up dialog box asking: Abort Don't Abort
AMSG() Pop up message box for an array of messages
ASCIITABLE() Pops up an ASCII table for character selection
BROWSE2D() Popup tbrowse of 2 dimension array (array of arrays)
DELREC() Dialog box to delete/undelete current record
EDITMEMO() Performs a windowed memoedit() on a memo field
EDITMEMOV() Performs a windowed memoedit() on a string
GETCALC() Pops up a quick 'solar' calculator
GETDATE() Point and shoot calendar
HARDCOPY() Prints current record or memo fields to printer
MAKEBOX() Draws a box on the screen with options, & save
MCHOICE() Creates a box for an Achoice call
MESSYN() Popup YesNo prompt box
MFIELDS() Pops up an selection box for current dbf fields
MFIELDSTYPE() Pops up a list of fields of given type(s)
MSG() Displays up to a 9 line message in a window
MULTMSGYN() Multi-line popup message - yes -no
ONE_READ() Pop-up window with 1-4 Say/Get combinations
P_READY() Determines if printer is ready, prompts user
PLSWAIT() Pops up a 'Please Wait' window or removes it
POPCOLSEL() Popup color grid for selecting a single color
POPEX() Pops up an achoice for a certain filespec
POPMONTH() Popup month selection
POPREAD() Pops up a box with 1-5 say-get combinations
POPUPDIR() Popup of a given directory for file selection
POPVDATE() Pops up a picklist of virtual dates
POPVYEAR() Pops up a picklist of virtual years
PROGCOUNT() Perform a count with a progress box
PROGDISP() Displays progress bar in box created with PROGON()
PROGEVAL() Perform a Database DBEVAL() with a progress box
PROGINDEX() Perform an index with a progress box
PROGOFF() Removes a progress bar box created by PROGON()
PROGON() Initialize and display a progress bar box
QUIKREPORT() Runtime pre-defined report printing module
S1LABEL() Prints a single label
SACHOICE() Achoice replacement, w. exception codeblock
SBSHADOW() Draw a shadow around a box
SBUNSHADOW() Removes shadow drawn with SBSHADOW()
SGETMANY() Virtual (scrolling) gets in a popup box
SPOPORDER() Popup allows user to change viewing (index) order
SPOPSEEK() Popup seek based on present index keys
STAGFIELDS() Tag fields
TAGARRAY() Tag selected elements of an array
TAGMARRAY() Tag elements in muti-dimensioned array
UNBOX() Removes a box created by makebox()
VERTVIEW() Pops up a vertical view of the current record
VIEWMEMOS() Popup viewing (non-edit mode) of memos
Screen
------
ATT() Colors a section of the screen, leaving the text intact
BXX() Draws a box on the screen of a given color
CLS() Clear the screen with optional color,character
COLPIK() Allows selection of colors from a list
ENHANCED() Returns color integer for ENHANCED setting
FADEAWAY() Fades screen away
PRNT() Writes a string of a given color at row, column
SS_CLOSEH() Restores screen in a horizontal close fashion.
SS_CLOSEV() Restores screen in a vertical close fashion.
SS_FADE() Restores screen in a fadeaway fashion.
SS_FALL() Restores screen in a fall from top fashion.
SS_FOLD() Restores screen in a fold to middle fashion.
SS_HBLINDS() Restores screen in a horizontal blind fashion.
SS_IMPLODE() Restores screen in an imploding fashion.
SS_RISE() Restores screen in a rise from bottom fashion.
SS_SLICE() Restores screen in a slicing fashion.
SS_SLIDELEFT() Restores screen in a slide left fashion.
SS_SLIDERIGHT() Restores screen in a slide right fashion.
SS_SPLIT() Restores screen in a split from middle fashion.
SS_VBLINDS() Restores screen in a vertical blind fashion.
SS_WIPEH() Restores screen in a wipe from left fashion.
SS_WIPEV() Restores screen in a wipe from top fashion.
STANDARD() Returns color integer for standard setting
UNSELECTED() Returns color integer for UNSELECTED setting
XBXX() Draws an exploding box on the screen of a given color
String
------
_WILDCARD() Wild Card String Compare
ADDSPACE() Pads right of string with spaces
ALLBUT() Returns all but last x characters
ARRANGE() Rearranges text in a string
CENTR() Centers a string in x spaces
CRUNCH() Moves spaces in a string to end of string
LJUST() Left justifies a string
PROPER() Capitalizes first letters of string, lowers rest
RJUST() Right justifies a string
STARTSW() Determines if a string starts with another string
STRETCH() Imbeds characters in a string
STRPULL() Extract text between 2 characters
SUBPLUS() Returns multiple substrings
TAKEOUT() Extract a portion of a string between delimiters at
VAR2CHAR() Converts any type variable to character type
SuperLib Environment
--------------------
INITSUP() Sets SuperLib system interface vars for MONO or COLOR
SATTCOLOR() Sets up the the system color settings for color monitor
SATTDIRECT() Sets up the the system color and interface settings directly
SATTGET() Sets up SuperLib environment variables from colors.dbf
SATTGETMEM() Sets up SuperLib environment variables from colors.mem
SATTMONO() Sets up the the system color and interface settings for mono
SATTPICK() Sets up stored SuperLib environment vars with picklist
SATTPICKDEL() Picklist deletion of stored color sets
SATTPICKPUT() Stores SuperLib environment variables with picklist
SATTPOP() Pops previously pushed SuperLib interface variables
SATTPUSH() Pushes the current SuperLib interface variables
SATTPUT() Stores current SuperLib environment variables to DBF
SETCOLORS() Interactive color setting interface
SLS_*() Series of functions for system settings and colors
SLSF_*() Series of functions to determine system file names